﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _1_6 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        using (DataClassesDataContext mydata = new DataClassesDataContext())
        {
            var rd = from a in mydata.a01106
                     where a.qiyeid == Convert.ToInt32(Session["qiyeid"])
                     where a.DATA_MONTH == Convert.ToString(Session["ShenBaoNianDu"])
                     select a;
            foreach (var r in rd)
            {
                YSZL.Text = r.USE_COUNT == null ? "0" : string.Format("{0:#.####}", r.USE_COUNT);
                HJ.Text = r.SUM_YEAR == null ? "0" : string.Format("{0:#.####}", r.SUM_YEAR);
                ZLS.Text = r.TAPWATER_COUNT == null ? "" : string.Format("{0:#.####}", r.TAPWATER_COUNT);
                DXS.Text = r.GROUNDWATER_YEAR == null ? "0" : string.Format("{0:#.####}", r.GROUNDWATER_YEAR);
                DBS.Text=r.SURFACEWATER_YEAR==null?"0":string.Format("{0:#.####}", r.SURFACEWATER_YEAR);
                QTS.Text=r.OTHERWATER_YEAR==null?"0":string.Format("{0:#.####}", r.OTHERWATER_YEAR);
                CFYS.Text = r.CIRCLE_COUNT == null ? "0" : string.Format("{0:#.####}", r.CIRCLE_COUNT);
                CFYSLV.Text = r.CIRCLE_PERCENT == null ? "0" : string.Format("{0:#.####}", r.CIRCLE_PERCENT);
            }
        }
    }
}